Object-Relational Representation of a Conceptual Model for Temporal Data Warehouses
نویسندگان
چکیده
Temporal Data Warehouses (TDWs) allow to manage timevarying multidimensional data by joining the research of Temporal Databases and Data Warehouses. TDWs raise different issues such as temporal aggregations, multidimensional schema versioning, etc. However, very little attention from the research community has been drawn to conceptual modeling for TDWs and its subsequent logical representation. In this paper, we present a mapping transforming our conceptual model for TDW design into the conventional ER and an object-relational models. For the latter, we show some examples using the SQL:2003 standard. We include the mapping for time-varying levels, hierarchies, and measures. We also discuss the inconveniences of a pure relational representation.
منابع مشابه
A conceptual model for temporal data warehouses and its transformation to the ER and the object-relational models
The MultiDim model is a conceptual multidimensional model for data warehouse and OLAP applications. These applications require the presence of a time dimension to track changes in measure values. However, the time dimension cannot be used to represent changes in other dimensions. In this paper we introduce a temporal extension of the MultiDim model. This extension is based on research realized ...
متن کاملA Conceptual Model of Temporal Data Warehouses and its Transformation to the ER and Object-Relational Models ?
The following formalization is inspired from [2]. We first describe notations, assumptions, and meta-variables required for defining the abstract syntax and the semantics of the MultiDim model. Next, we give the abstract syntax of the model that allows the translation from the graphical representation to the equivalent textual representation. Finally, after describing the auxiliary functions, w...
متن کاملThe Conceptual Integration Modeling Framework: Abstracting from the Multidimensional Model
Data warehouses are overwhelmingly built through a bottom-up process, which starts with the identification of sources, continues with the extraction and transformation of data from these sources, and then loads the data into a set of data marts according to desired multidimensional relational schemas. End user business intelligence tools are added on top of the materialized multidimensional sch...
متن کاملDesigning Data Warehouses with OO Conceptual Models
M ost developers agree that data warehouse, multidimensional database (MDB), and online analytical processing (OLAP) applications emphasize multidimen-sional modeling, which offers two benefits. First, the multidimensional model closely parallels how data analyzers think and, therefore, helps users understand data. Second, this approach helps predict what final users want to do, thereby facilit...
متن کاملA Design Methodology for Data Warehouses
The objective of this work is to develop a design methodology for data warehouses. It is based on the three level modeling approach with emphasis on conceptual modeling. Logical design to the relational model and physical tuning in this environment will also be treated.
متن کامل